The Details tab on the Sessions view provides a launch-pad-like interface that lets you choose which type of sessions you want more detail about.
Active User Sessions
Lists all active sessions initiated by database users on this server, providing a performance summary for each session and a link to detailed session properties. From that view, you can also kill a user session.
Blocked
Lists all blocked sessions on this server, providing a performance summary for each session and a link to detailed session properties. From that view, you can also kill the blocked session.
Blocking
Lists all blocking sessions on this server, providing a performance summary for each session and a link to detailed session properties. From that view, you can also kill the blocking session.
Blocking Chain
Displays the hierarchical relationship between the blocking sessions and the blocked sessions, from the session that started this blocking chain to the most recently blocked session affected by it.
Top CPU Consumers
Lists the 10 sessions that are consuming the most processing resources on this server, providing a performance summary for each session and a link to detailed session properties. From that view, you can also kill the session.
Top I/O Consumers
Lists the 10 sessions that are creating the highest I/O load on this server, providing a performance summary for each session and a link to detailed session properties. From that view, you can also kill the session.
Top Memory Consumers
Lists the 10 sessions that have allocated the most SQL Server memory on this server, providing a performance summary for each session and a link to detailed session properties. From that view, you can also kill the session.
Top Waiting Sessions
Lists the 10 sessions that have been waiting the longest time (in seconds) for a resource to become available to execute their statements or commands.
< < Close Help